Calculated field

A CALCULATED FIELD displays the result of a calculation (performed on other fields containing data) rather than data. The value is recalculated every time a value in the expression changes.

Calculated fields can be added to a query or a form. No calculated fields should ever be used in a table because Access performs the calculations as needed (as requested by a query) and displays the results on forms or reports. If a calculated field is used in a table, changes in values in the expression may not be reflected in the field.